No pond exists on Mt. Moon's main floors in HeartGold/SoulSilver. The area is a dry cave system. The only water is an underground lake on B2F (basement floor 2) where wild Psyduck appear (and Golduck in HeartGold specifically).
If you're hunting water-types on Mt. Moon, B2F is your only spot—and only for Psyduck/Golduck. No Magikarp, no Poliwag, no fishing spots on upper floors.
Bring Repels and head straight down if that's your target.