OP, "if" you really have to move here the old established villages are better. However many, including mine, have no bus service. This becomes important when yr dc's are teenagers as you have to take them everywhere. Then, pay for driving lessons as soon as they are old enough then buy them cars if you ever want to have a random wine again!
Wifi/broadband poor. 5G is a dream as we just about get 3G in this village. Landline is essential. Sky TV , as no cable and if its windy, listen to the radio. We also have no gas and that is common, oil only.
In rural villages here it is advantageous if you can trace your ancestors back 1000yrs. We are lucky as 2 of our ancestors moved to this very village 170 yrs ago from Wales and both are buried in the local 1000 yr old church. Quite by chance we moved here 100's of yrs later and discovered on ancestry but the name on the grave carries weight.
The culture is generally different here and i have found that a southern diverse culture/upbringing not necessarily in keeping with this county. I have a dear friend from Sheffield here also, she does not much care for the place either.
I have been to Yorkshire many times and it is a beautiful and warm county. If i had a load of money i would move me and my DC's there! Full of culture, steeped in history and friendly people. What a beautiful place to be. I am not from Yorks btw. If i knew then what i know now i would have stayed put where i was.
I too followed a DH. Not my DH anymore as i blamed him ultimately for this shambles! Unless your husbands new job is paying mega bucks and you can suffer this, i would seriously look at what you already have around you... and value it... and don't put a price on it!
There is no price can be put on a support network, your family, familar places and people and things. You wont find those here.