A man drank a bottle of vodka, fell asleep face-down in the sand, got up and stumbled around, before relieving himself in full view of stunned beachgoers, a shocked family said.