Councils cannot rely on government handouts and grants to spark economic growth - they need to work with the private sector, authority leaders have said.