Thank you everyone for your help. Here is what I got by applying a water shader to some parts of the scene... It's not proffesional, but I learned alot by doing this scene...

by the way, the areas where there is like a 'pool' of water, I couldn't figure out how to get that effect, so I made a poly cylinder, scaled it so that it would be like the surface of the water, then applied the shader to that...

I don't know if that would have been the best way to go about it, since I know that it's not going to move at all when the particles hit it (like real water, which would ripple)

Anyways, the image is attached. What else should I do? (other than making the fountain mesh look nicer )