Visit Britain gave the attraction the only 'hidden gem' award in the North West