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.
Quad biking and go-carting are available in Macclesfield and Buxton.
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)!