It is called an "inlet"or a "cove". It could also be called a "bay". Come to think of it... It could be called (if salty), an "estuary".
Is it moving? If so, a river. I know that the Long Island Sound is a body of water with land on both sides, but I am not sure if it moves.