The Scotch Whisky Association has confirmed the appointment of a former UK ambassador as its new chief executive.