Public Opinion on Councils hits record low