A sprawling, French Normandy-inspired retreat becomes both charming and comfortable at the hands of a dream design team