Thanks to everyone who responded to my post. I ended up going to WalMart and buying him an inexpensive spinning rod outfit - the Shakespear Ugly Stick - and some PowerBait. He was so excited, he put the hook in the water before I had a chance to put some PowerBait on it and within seconds caught a fish. We started off at Whalom Pond and fished off a dock, catching three fish there.

Later, we went to a little spot I know on the Squannacook in Townsend and, although he didn't catch anything, he came close to getting a nice brown I saw chasing his lure. I estimated it at around 15". Fortunately, he saw it too, which was exciting. While there, a nice size turtle came swimming down stream just a few feet next to us. He found that cool as well.

Here's one of him with his fish:
Attachment 5115