The Cauldron Snout Waterfall is known as a must-visit spot in County Durham.