I've not been to Chatsworth, though it's definitely on the list! I've been to Castle Howard a few times, and they are in a similar situation, as the live-in Dukes of Norfolk who have apartments in the house. It was Brideshead in Brideshead Revisited and often features in dramas, and does a good line in weddings.