No Psychic-type Pokémon can learn Waterfall.
Reason: Waterfall is a physical Water-type move. In the main series games, it is almost exclusively distributed to Water-type Pokémon (and a few exceptions like certain Rock, Ground, Dragon, or Normal types via HM/TM). Psychic-types do not have access to it through level-up, TM/HM, breeding, or Move Tutors in any generation.
If you need a Psychic-type that can navigate waterfalls in the overworld, you must use the HM on a compatible Water-type in your party.