You will need to have an opaque or masked water material (so that it renders in the depth pass). Then set a high “near blur” value on your post process depth of field to cause the edge of the waterline closest to the camera to blur.
Also, you will probably want to use a pixel depth opacity mask to ‘cut off’ the edge of the water closest to the camera.