Council asks mayor to resign