Green light for major refurbishment of Harrogate Hydro