Thousands of fans will be able to enjoy the show at the royal retreat