Society of Motor Manufacturers and Traders (SMMT) chief executive Christopher Macgowan will leave on 31 December.