Does the word pipeworks need an apostrophe?

It is a noun, and the apostrophe is used for possessives (e.g., "the pipe's length") or contractions (e.g., "it's").

"Pipeworks" is a singular noun referring to a system of pipes or the work done on them.