Fodder in Harrogate has reopened after a major refurbishment.