That particular piece of Hardware is commonly referred to as a bulkhead fitting
Regard the image and the bottom right hand corner. It is labeled as a 'slip', because the inside is threadless.
The Suiwoton selection is labeled NPT because of the internal thread - those are the ones I like. With a little pipe dope on there you can take them apart and put them back together as required.
They come with gaskets for a reason ; you will need no silicone for this project.
If you have gravity at your house, then you don't need a pump. Gravity will siphon water through a three-quarter inch hose at 11 gallons per minute. If my math is correct , that's about five or six gallons a second.
1 inch NPT to 3/4" Barb fitting.
( will look similar to this)
3/4-in Automotive heater hose is luxurious and expensive, but it will last forever in this application. It's nice and supple, easy to work with.
Your shut off valve will be the most expensive component in this circuit.
Don't be afraid to splurge on a nice one, you will resent buying a cheap one every time you turn the tap.
Mount the valve nice and securely, for easy one-handed operation.