A health promotion initiative targeting drug injectors — funded by an Elton John charity — has been rated a success by users and pharmacy staff, according to an evaluation.