Following an extensive renovation programme, the historic property which features an 18-hole championship golf course will open in Q3 2024