Buxton Opera House has an excellent 7-day programme of family entertainment as well as some opera.
Try a visit to 'the Glyndebourne of the north', Clonter Opera
offers intimate theatre of operatic productions as well as Jazz and other musical events.
It's about 30 minutes drive and they'll cater for your interval dining if you don't want to take your own picnic.
Macclesfield has a great 'classic' cinema showing almost exclusively new releases.
Go-carting is available in Buxton,
and quad biking in Poynton.
if the children really do beat you into submission then you'll probably end up at Alton Towers, the UK's largest theme park (25 minutes)!