Councilman says the fatal shooting represents a failure ‘on multiple fronts’