Having led the contemporary art institution since its founding, he will serve as a special counsel to the board of trustees