CCTV to be upgraded by council