Light is the effect that produces the underwater look. Two main ways that can be used independantly or together. Volumetric spotlight and a Gel. I usually use the Spots Gel or the Caustics Gel in the Light Gels Material Group. Make sure your light is below to water line to get more control.