The venue is getting a £1.75million makeover and is due for completion by the end of 2024