A waterfall in the Lake District has been named among the UK's best by Go Outdoors with one visitor saying it's "pure magic".