Cork city is in the grips of an epidemic. Heroin use is rampant on the streets, with users taking the drug in the open, not caring who can see them. However, many are trying to get out of the habit, writes Liz Dunphy