San Francisco official resigns after backlash over controversial walking tour