Harrogate and Ripon care provider ‘requires improvement’, report finds