Malham Cove was a waterfall for a couple of days about 10 years ago. Never before in living history, and never since.
Goredale Scar is very impressive, and so is Janet's Foss, but that isn’t high at all.
Hardraw Force is the one you want. Aysgarth is also beautiful but wide, rather than a high drop.