Rentals now allowed in historic water tower on King Charles’ Sandringham Estate where royals spend Christmas