sounds like you need a bulk-head or through wall fitting or tank fiiting. Basically you drill the appropriate size hole place the fitting in the hole and then a rubber washer and large nut is screwed on the other side to form a water tight seal. Then a pipe fitting can be threaded into either end.
Here is an example of one
Bulk Head
Here is an example of one
Bulk Head