An ‘impressive’ residence in the Lake District, boasting a ‘magical’ riverside setting, is for sale.