A robust multi-agency crackdown has been demanded by a city councillor who witnessed heroin being sold openly in daytime in a busy public park in Cork.