Try to make pictures tomorrow to explain!
After have done a projet as this one (french lake!! so little 150m x 250m)
Draw a line on 2D or 3D and move it to show botton as the last picture.
or
get something like that:
And for 3D view water level and limite someting tlike that in transparency: