The city attorney shall be the legal adviser of the city council and all officers of the city in all matters respecting the affairs of the city and shall perform such duties as may be required by the city council or prescribed by ordinance.