The 'mind-blowing' restoration of the historic city centre site is nearly complete