it depends…
if player’s camera never goes under water, you can use simple cone static meshes with translucent materials. Just to get desired effect.
if this is for some underwater game, you should experiment with volumetric fog effects, particles, or even post process materials.