Hiya.
I don't think that is possible; fog in A6 is "spherical". What you could probably do is create/get a shader that does the same thing, then simply turn it off/on based on a distance from the waters serface. This shader would affect the players view; so when he's standing in water, he can see normally, but as soon as his head goes underneath, the shader kicks in.