Anything with pictures is good. Buy that. I subscribe to the "Family Handyman" magazine. Lot of good stuff in there every month.
Once you actually tackle a large project (preferably with some help from friends/family), you feel a lot more comfortable.
If you're messing with plumbing, turn off the water. If you're screwing with electrical, flip off the juice for the room you're working in at the breaker.
As stated earlier, buy good tools. It's worth the extra money. I usually go with Craftsman or Kobalt because of the lifetime warranty. For power tools, go with DeWalt. It's more expensive, but when I borrowed them from friends and compared them to the stuff I have, it's no contest.