If you can stand a big climb, the Kinder Downfall is an amazing waterfall, if you catch it on the right day the wind catches the water and it goes straight upwards. (You stand on the top of the waterfall)
Video here. (It doesn't have to be a horrible gale for it to happen, but it helps)...