Fog in water

How do I add fog to water, to make the water appear hazy? I tested water in a map I’m working on, but it’s perfectly clear, so how do I add it? And is it possible to give it a color as well?

Make sure to never use the “cheap” and “DX7” water textures, I don’t think they support it.

Also, if you have moving water, Source can’t handle moving the fog along with it, so you can’t have fog in moving water.