Hidden in the heart of the Yorkshire Dales is a scene of such natural beauty that even Hollywood filmmakers have flocked to it