What is large body of fresh water called?

There is no general term for the connection between a lake and the ocean that it is an arm of.

The area where a river or stream enters the ocean is a mouth, also possibly a delta or an estuary.