Harrogate set for 'greatest investment in town centre in decades'