In the heart of the Yorkshire Dales an 'idyllic' lake hides an ancient legend of a sunken city beneath its tranquil waters