You also need to create a post processing volume that encloses the entire water area so that when the player steps in the water, that particular post processing effect kicks in.
As said, look at the post processing documentation.
Fog, scene color, depth of field, blur and other depth based tricks will help you make a great underwater post process material!