Cork City facing 'significant challenges' around drug use