Water doesn’t have color, it is clear, it either reflects what is above it, or it refracts what is below it. Hence the reason the base is gray.
The key to decent looking water requires four components, reflection, refraction, opacity, and the lighting. Every different lighting setup will require an adjustment in the other three.
Just based on what is posted, I’d reduce opacity to 45-50%, up reflection to atleast 85%, set refraction at 65% ( 1.33 refraction value) and try out your current lightset, see how it works. The other thing that will change the color of the water is the color of the darkdepth prop below the scene, changing its colour will be refracted into the water surface.
I’ll be providing a small update for single click ds mats that use the same textures but with adjusted settings and a basic lightset. Expect that update very soon.
Please realize that this prop model was designed to be used with procedural textures in vue, poser, carrara, bryce etc. which all have their own water shaders for their programs. Now if you do want that most excellent DS/Reality/Lux water seen in some of the promos, then you have to use the Reality plugin.