Yorkshire Agricultural Society appoints new chief executive