New CEO appointed at Harrogate care provider