Great fun as a construction project for KS2 but the science element is more suited to KS3.
Vortex cannons are brilliant and really simple to make. The science comes in when you think about why they do what they do. This resource is a PDF file which comprises printable instructions, an outline of the science involved and lesson presentation suggestions.