Harrogate may be in line for a new multi‑million‑pound investment that aims to transform specialist care for older and disabled people.