Not sure what the wattage is on that light, but if *IF* it is not too much, and the you plug it into a GFCI socket, you might be able to change the fat black cable to something nearly invisible and very flexible... like speaker wire.
(Note -- of course I would never recommend something like that, because you run the risk of electrocuting yourself and the whole neighborhood)
Like Hoppy said, no need to sand before spraying Krylon Fusion, just clean the pipe well. The trick is not to spray for too long in one place so it starts to run. Better to do several lighter coats.