The CEO of Sidney Frank Importing is leaving the firm to head up George Clooney's new spirits import company.