Far from being the arm which extended the dead hand of bureaucracy, council architects’ departments fostered an aspiration, ingenuity and innovation which benefited UK architecture as a whole – and can do so again, writes Ruth Lang