I think you’ll love the move, but definitely visit first, and visit soon. It’s very important that you experience Scotland during winter.
We live in the north of Scotland. We went to a wedding in Stoke in late September a couple of years ago - it was boiling! All the locals were wearing coats, but we were in our t-shirts. What I’m trying to say is, don’t underestimate how crap our weather is, or how windy it is, relentlessly windy. Our hottest day of summer last year was 14deg. (which we thoroughly enjoyed, it was fantastic!)
Carers will always be highly sought after. Handyman is always in fair demand too. As a pp said, we don’t really ‘do’ flat roofs here, they just don’t work.
Be prepared to be a 2 car family, you’ll miss the London public transport service. Also, factor in driving lessons for as soon as your teens turn 17. It’s pretty much a must for kids to be able to drive, it’s quite a life line.
We do have crime locally, but it’s negligible compared to London.
Will your kids be staying on locally once they leave school? If they know roughly what career they’re likely to follow research if that job can be done anywhere locally (that’s if they’d rather stay close to you and your wife once they leave home).
It sounds an exciting move though!