Upstate mayor appoints new police chief