One local councillor starkly admits 'we've failed', as residents say they feel forced to stay indoors and there's no point in calling police to tackle local thugs