Trying again.
Please don't worry. I know numerous people who have made just this move and love it. I moved from the south (lived just outside London, but worked in the City) 7 years ago and have never regretted it.
The most obvious pluses are the friendliness of the people, less crowding and easier access to services such as GP, Hospitals etc. the beautiful rural environment outside the major cities and the absence of aggression on the roads.
I thought I might struggle with a lack of cultural facilities once I left London, but now realise just how wrong you can be. We have wonderful music at the Minster, great theatres etc and the bonus of being only two hours from London, even closer to Newcastle and not that far from Edinburgh.
In terms of your specific worry, it is worth understanding the subtle differences between the major towns / cities.
IMO Leeds is the focus of much of the professional / IT work in N Yorkshire, whilst York experiences more Tourism and Harrogate is a little quieter. York and Leeds both have highly rated Universities and the lively student culture that reflects that.
Many professionals live in the Golden Triangle (York-Harrogate-Leeds) and house prices in the area clearly reflect that.
East of York is more rural with some charming market towns / villages in the corridor leading to the coast, but it is important to consider where you will be working and your commute. The A64 is a nightmare during summer weekends.
Another less obvious feature of areas to the East of York is the number of stunningly beautiful villages in the Wolds / Howardian Hills which are predominantly owned by large Estates. You can rent beautiful houses in these villages through the Estates (Castle Howard, Garroby Estate, Hovingham Estate) but it is much harder to buy.
Hopefully this might put your mind at rest, but if you have more specific questions just ask.