this is a temple like scene I'm working on. The modelling is close to finished, but I will have some problem with water fountain. I would like to make a water as realistic as possible. I don't have picture to describe you exactly what kind of water I would like to get, but you all know how does true water (from fountain) looks like. I could perhabs use particles to simulate water coming out from pipe, but how to do the water that just lies around? The effect I would like to get is similar to "shader 5" on this site:

link

And this will be a short movies, so it will be verry important how will water looks like.
I'll make you a picture showing where will be water, so you'll maybe understand better my prob.

so, any tips on this one?