Police were called to the popular waterfront after the body was spotted several metres offshore.