Water Fire by compressed air and Water

Use a large resovoir tank with small pipes coming out and solonoid valves to control the flow presurise the tank and use a (computer) or other control device to open and close the valves in time to the music (midi) controller. You can also shine light into the water jets using fibre optic piping.. Ther I have got you started now go out and make it.

Are you wanting to make something like the Bellagio fountains?

http://www.youtube.com/watch?v=UjCsKMAczrI

The expert in this field is Wet design

http://www.wetdesign.com/contact.html

Now that's just 'showing off'.