Far away from what is the question, and to what? If you move to somewhere your southern friends could come and enjoy visiting, and you keep in touch with them, you will have most of your family and contact with your friends, and you can return to visit the south and indulge in whatever you miss by moving.
If you move to a small house with no room for visitors, in an area that does not encourage them, you will be restricted to family plus the new friends you will undoubtedly make. and your other son and his family will miss you, as you say.
Don't expect everything to be exactly the same as it was forty years ago, either. Areas change, for some things that is for the better, for others the worse. Shopping will be vastly better than you imagine it, with branches of all the big chains. Cities will be cleaner, in general. The weather is not so awful as it is rumoured, but the gardening season starts weeks later and finishes weeks earlier.
Can you go and stay with family for several weeks before you decide, to rerally experience the change?
And it is not the far north. You can probably get to London for the day without setting the alarm for four am.