Fluid pipes can include a number of mods. BuildCraft have waterproof pipes, but require specific pipes (like wooden) and a power source to draw into them. Thermal Dynamics has Fluiducts, which similarly require (in most instances) a servo to draw liquid into them. Extra Utilities gives Liquid Transfer Nodes, which (I'm not particularly familiar with them) which can be used by the knowing to great effect. EnderIO has likely the most user friendly pipes available, as they come with built-in servos and can be placed in the same block as power and item conduits.
I tend to use a few types through my builds, depending on the task I need done (and the throughput). Some machines auto-output into pipes, while others (and most tanks) need a method of drawing from them. Try a few and see what works for you.
Edit: Worth mention that the lowest tier of TD Fluiducts will burn when carrying hot liquids (lava/steam).