Rotherham Metropolitan Borough Council has approved the decision to sell a Volvo car used by the deputy mayor for civic engagements.