Welcome to the forum. There are a number of "small, local" rallies that are hosted by RV clubs, organizations, campgrounds and civic organizations throughout the USA and Canada. Many of them aren't advertised on a wide scale and "outsiders" never even hear about them. Do some "google searching" and you can find some of them that might interest you.
Good Sam is a large RV service organization. You've probably heard of them before. While this forum doesn't endorse any "RV clubs" I can say that Good Sam has a very good reputation. They host a number of events from local rallies, state events, RV shows, and a host of other types of events. You can see a list of what's scheduled here:
http://www.goodsamclub.com/community/events.aspx
Again, welcome to the forum, we're happy that you decided to join us.
Happy RVing,