King Charles has opened a historic Victorian water tower on the Sandringham Estate in Norfolk for overnight stays for the first time, marking a new chapter for the royal property.