From Goodwood to Broughton, aristocratic estates are opening their gates to the wellness movement. But which stately home retreat takes the crown?