Master_Chief from the Halo mod has been working on transparent volumetric water. You can change the water color/depth from within the mission editor.
Unfortunatly it is still in an early stage of development, and alot of problems need to be fixed before it can be released.