The former Diageo CEO, who passes away following a brief illness, was hailed as “one of the finest leaders of his generation”