The man was pulled from the water at the beauty spot