The picturesque Lancashire village is a hidden gem boasting a Grade II*-listed church and River Yarrow winding through cobbled streets