The Council shall appoint a City Attorney who shall serve at its pleasure and shall fix his/her compensation. The compensation set by the Council for the City Attorney shall be in contemplation of the normal duties of that office. Special compensation may be provided at the discretion of the Council in cases of appeals to or litigation commenced in the Federal Courts, the Circuit Court or State Supreme Court, work requiring extensive hearings before quasi-judicial or administrative tribunals, for legal work in connection with the issuance of bonds of the City, and for condemnation proceedings. No such special compensation shall be given by the Council except in accordance with an agreement between itself and the City Attorney made before the service, for which such special compensation is to be paid, has been rendered.