I use the default clear-water when I want to see all the underwater excitement.
Look for 'unReallUBoat' mod to change it (and/or other features back to original).
Unfortunatly changing the water will affect your night-sky. I use the 'clear' water if I'm playing during the day (so I can see where I'm going at night

) and BeeryWater1.44 when its dark because it looks so nice