The monarch has opened The Water Tower, located on his vast Norfolk estate, for overnight stays for the first time since it was built in 1877