A petition has been launched calling for the resignation of a councillor who has suggested people should "live less extravagantly" if they have too much waste