The public must get more powers to scrutinise the use of CCTV and other forms of surveillance, council leaders say.