A safe haven for a scandalous couple, the French country home of the Duke and Duchess of Windsor is about to open its doors to paying guests for the first time. John Lichfield takes a tour