Welcome. Don't know if this is the type of thing you looking for (a bit rough because I just knocked up a quick texture rather than look for something proper), the left tube has simulated holes using transparency, but it does slow the render down a bit, the right one has a bump map (gives the appearance things are sticking out or sinking in a bit), and although not actual holes, may be worth considering, especially as proper holes won't show up much anyway on a 100 ft length of pipe.