Councillors should undergo taxi-style "knowledge" tests to show their competency, an opposition leader has said.