Upstate police chief, several police officers resign, mayor says