If you want to run the pipe through the wall, you're going to need somebody who know what they're doing with a drill. Otherwise, for a professional look I'd call a plumber. A plumber could knock it out in no time, and it wouldn't cost you as much as you think. PVC is cheap, and depending on the size of the home, I wouldn't think that it would cost more than $200 tops.
Also, make sure that you put some valves in the pipe on the 1st floor so that you can control the flow without having to go into the basement.
If you've got carpet, you could drop it right through the floor not problem...slice the carpet where the pipe is going to go down. run the pipe through...If you ever move the tank you can easily fix the hole and you'd never notice the slice in the carpet once you glued it back down.
If you've got hardwood floors that's a different story.