A long-standing Diageo executive is to exit the company 27 years after he joined its Guinness subsidiary.