Comprehensive renovation creates a modern-functioning home with all the character of a grand historic villa