Exclusive: Exasperated charity ‘standing up for local residents’ with self-funded plan to reduce drug harms and stop discarded needles littering streets