PVC pipe and fittings are available pre-colored. Look for "furniture grade" PVC on amazon or other vendors.
But yeah if you already have the standard white stuff, krylon fusion is fine. Honestly, I don't think I would be picky about brand. Just make sure it's fully cured (a week, minimum) before it goes underwater.