UK City of Culture 'being overrun by zombie druggies', as some liken it to 'Shaun of the Dead'