Plan approved to demolish Harrogate social club for flats