Most you should be able to? Some do have some strong fog effects, but I think most you can see players beneath to a reasonable depth.
Do you have an FPS config? I'm not sure if those can disable rendering beneath water.
The most transparent one I can think of is hydro water, which doesn't even use the standard water shader iirc.
Here's a video of the different water types included in the game.