Wales' outgoing auditor general has said some of the country's councils are ‘very close' to issuing section 114 notices.