Surrounded by lush greenery and packed with characterful buildings, cobbled streets and history, it's not surprising the Yorkshire location has caught the eyes of film producers.