Ben,
I am also a member of the Rochester Bassmasters and have been since 2008. I spent 3 years as a non-boater and learned more than I ever thought I could. This year they have also started a mentor program, which pairs a newer, less experienced angler with a more experienced angler. This could help you, not only to learn about fishing and tournaments but also to get to know the great group of guys that are in the club.
When I first started in the club I had no boat and I didn't know anybody who had a boat that was willing to take me out. Now, I have a boat and know a bunch of great guys, heck I've even won a couple of tournaments, but most importantly I know a whole lot more about fishing than I did when I first started with the club. Ww2farmer is right, you can go out and fish the open tournaments throughout western New York, but if you are anything like I was, no boat and no fishing buddies, then a club like the Rochester Bassmasters is the perfect place to be!