I would believe all the info you need is in article 680.52 (A) and (B).
We use PVC when we do fountains, or LFNC, we use DB type wire nuts, and a good removable encapsulate potting compound, such as the GE pour and seal. and make sure you use wet location conductors, or cord with a "W" suffix.