Southampton City Council have been criticized for offering a £200,000 a year salary despite ‘teetering on the edge of bankruptcy’