This video was done just using a pipes style (there is a couple of them in the library), and "painting" the spline in the viewport. That's all.
If you need help to create the style, please see our tutorials
page. There are plenty of them, and have plans to release more on a regular basis.