Weberence.com

William Pye has managed to combine art with cool, with his latest creation Charybdis, ie the Vortex Fountain. It does not shoot water like normal fountains do, instead it creates a huge vortex in its center. The acrylic transparent cylinder and its circularly pumped water will definitely dazzle your neighbors and friends.

[via]

The FUNtains are interactive water fountains that combine art, science and fun! These fountains combine the flout principles and instead of air, water creates the sound.
It is made by EyeTrap (Canada) and you can find it in various places such as the Ontario Science Center
See the video of it below
[via]