Horror as body found floating in water off coast of popular beach