San Francisco’s newest supervisor resigns amid pet store controversies