I would suggest the Lake District, as that would not be far to drive and has quite a range of possibilities. I took my husband to a lovely hotel near Ambleside , which was a treat for his birthday and had a jacuzzi etc in the room, beautifully peaceful in its own grounds but just between Ambleside and Windermere. Think it was called Middlewood, but not sure. You could just check hotels in that area.
One of the good things there is your options are quite varied, to suit your own interests. I used to work for National Trust in that area ,and if you are members there are quite a few places in the area. Some lovely gardens to visit and you could also have some rather peaceful but enjoyable times if you chose to go on a boat on either windermere or ullswater.
Then at the more southern end of the lakes you have Newby Bridge where there is a hotel and in that area there is a sculpture walk in Grizedale forest, and dont know if it is still available , but they did have a little submarine from newby bridge area but couldnt see much in the gloom. Dont know if it is still there but you could actually go in a hot air balloon there.
Also there is quite a bit of public transport , so that you could actually have a really good time leaving your car at the hotel and getting a bus, so that you could just enjoy looking at all the scenery, without worrying about parking or watching the road.
If he insists on driving a lot, I also suggest what I always do when travelling. Take a box with you with plates and cutlery, mugs etc etc and thermos etc. You do not have to use it all the time, but it is very good if you want to buy some food in say Ambleside where apple pie house sells lots of good food and had wonderful custard tarts to my memory. Not only cheaper than eating in a cafe all the time , but the great pleasure of being able to drive - in the weekdays when it is quieter - to whatever you fancy. A quiet drive through some woods, or up to Kirkstone Pass or whatever and you then have the flexibility to just stop at somewhere that appeals to you, and can sit in the peace and quiet and enjoy a lovely view to yourselves. Then you are not forced to go into a town just because you are hungry. I also have a folding chair and both sunglasses and a fleece at the ready for comfort, which allows you to be totally independant. (Of course I take all my litter home!)
An even closer place you might like to consider is Saltburn. It is a favourite place of mine, with lovely clean beaches, a great funicular to go down to the beach or the pier, and very quiet with a little railway and some gardens above the beach. But again there you have the peace and quiet and then you could go to Scarborough, Bridlington or Whitby easily from there for a wide range of possibiities. The bus ride along the coast is also very good if you dont want to drive. So you would have coast and also the north york moors close by. You could also enjoy the peace of the wolds and could travel to York.
I hope this gives you some idea that might help and that you have a lovely time wherever you get to. If you stay in Yorkshire of course you then have York and Harrogate if you want a time in a more built up area and there will be public transport to them too. The Park and Ride is definitely the best way to visit York without strtess. Enjoy whatever you choose.