This Northumberland village is home to a breathtaking castle that doubled as Hogwarts in the Harry Potter films