Aristocrats are having to pack up and wave goodbye to their country seats. Vicky Ward on the decline of a landed class