The deputy leader of Rotherham Council has resigned from the Labour Party in protest over the government’s welfare reforms.