congrats on your new upcoming puppy.
If you're going to train for agility, go ahead and train for competition. You'll do better and that way if you change your mind, you don't have to re-train. Believe me. I started doing agility with Digital the brindlewonderkid 11.5 years ago with an idea of just to see if he liked it and where we could go with it. Digital is now retired with 30 titles to his name; most are agility titles and he's been ranked in the top 3 agility basenjis in the US for 7? years. I'm now on my 3rd agility basenji, Zest the superstar in training. You can see her here:
Clean Run is a great resource and has many good books/dvd's listed here:
Building Blocks for Performance
Really Reliable Recall (comes in booklet and dvd format)
and if i had a new puppy coming in right now, I'd get Sander's Pre-Sports Puppy dvd, but I haven't seen it.
I also like the Puppy Puzzle, but it's better for general puppy info, not so much on training/agility.
I'd also get Control Unleashed book and if you've trained dogs with more traditional methods, i just finished reading The Thinking Dog and really liked it. The Crate Games dvd is also very popular. Check your local library or amazon or dogwise.com to find the best price.
Visit classes, ask about puppy performance classes. I've had several older puppies (6 months or so) come through my Control Unleashed classes. So you may want to ask about that too.
Good luck and post pics when you know more!!