Harrogate BID appoints new CEO