The local councilor initially started his campaign for the cameras in 2022, with approval now weeks away