How old are the grandkids?
Giants is good for a walk in trip, go have a look at Garlands (carefully!) and then back out.
Lots to do in Carlswark for kids, bit crawly, a bit wet but a good adventure!
Bagshawe is good too, but should be a BCA member for that (Free BCA membership for under 18s though)