The original phrase was "happy as a clam at high tide." Clams live in the sand beneath the ocean. When the tide goes out, they are left without any water, and have to survive on what they store in their holes. So when the tide is high, a clam is happy and has plenty of water for food and oxygen.