Los Angeles Council president resigns after racist remarks