This post is rather on the very short side. Creating water should be easy, and it is. The basic idea is to have a bunch of sine waves moving in the same direction at different frequencies and velocities. Modulating their amplitude will give you all the water goodness you require.
Check out the results: