Most good hardware stores should have galvanized pipe and pipe connectors available in 1/2" sizes near the gas or electrical conduit sections. Look for the electrical components in the lighting section, usually in a back corner where replacement sockets are stocked.
For the main housing you'll need:
* 1 x t-connector. There are several sizes available, make sure you get one with 1/2" connections on all three ends.
* 1 x 1/2" end cap
* 1 x reducer or coupler that goes from 1/2" to 1/4" threads
* 1 x 1/2" short threaded coupler. This is basically a really short pipe that's threaded the entire length.
* 1 x 1/2" floor flange.
NOTE: See step nine for an alternate list of galvanized parts if you want to hard-wire this sconce into a standard wall receptacle.
For the electrical connections you'll need:
* A candelabra base keyless socket. There are many types out there, but the ones at my hardware store were adjustable keyless sockets that you can extend to various lengths.
* Some two-strand electrical cable. Or, if you want to use this as a lamp rather than wiring it up to a wall switch, you can get an extension cable and add an in-line switch pretty easily. Or find an old lamp from good will and use the cable from it. Just make sure it's still in good condition without any frays or breaks in the insulation.
* A candelabra bulb. These are the lights typically found in nightlights.
* 1/4" threaded "steel nipples".
Note, you will normally find lengths of threaded brass tubes in what's labeled 1/8" IP or IPA. In order to connect to the 1/2" to 1/4" galvanized adapter, you need the 1/4" IP sections. They're just slightly larger with wider-spaced threads.
* A hacksaw (to cut the threaded pipe and candelabra sections)
* J-B Weld, either Kwik or normal version, depending on how much time you want to wait for it to set.
* Clay, play-doh, plumber's putty, or something else similar. This is used in a later step to create a "water dam" for drilling.
* 1/2" diamond hole saw, preferably a "core" version that drills out a plug of glass. I picked up a two-pack of 1/2" and 1" size bits
from Amazon, but there are various types for various prices on the internet or in your local hardware store.
* Water. Easy enough to come by, hopefully.
* A drill press. You could potentially work with a hand drill, but I wouldn't recommend it just for ease of use and accuracy.
* Rubber washers, or felt, or some kind of foam sheet, or cork.