Here is some tricks I used for this one.
Hope this could help and inspire people. Hope to see underwater renders

First the water is not a lake but a plane object with a water shader.
To simulate the water under this plane. I used a cumulus layer with a low density, here 0.04 ( otherwise it's too murky

).
You need to adjust altitude and depth. This fog must touch the plane (or at least be the nearest under the plane) but must not be over it.
You will need to change the cloud colour from the grey to a blue-green colour.
Then you can create both world and underwater world.
David