To get to it, you drive north off 16th St. onto the appropriately named Aqueduct St. After driving about a half mile, it dead ends very near a junk yard. Then you have to hop out of your car and (presumably trespassing) walk about a 10th of a mile back on a gravely path. At the end of your walk, you're presented with this:
Looking West:Aqueducts always get me. The juxtaposition of "tamed" and "wild" bodies of water always looks and feels very odd to me.
Note: these pictures were taken June, 2006.
UPDATE (2/4): Finally took a look at the birds-eye shots that thundermutt mentioned in the comments. Here's a shot of the aqueduct from the South: