Hi Edd,
The biggest weekly tourney is Friday nights at the Bonfire Tavern, Jewell and Wadsworth. It's a Bring Your Partner, but beginner teams get free entry. I think that when beginners (I'm going to go out on a limb and call you a beginner, unless you played in tournaments back in the day) show up they have one of two reactions:
1) "Wow, these guys are really good. Screw this!"
2) "Wow, these guys are really good. I want to get better!"
Unfortunately, it seems that most have the first reaction, but the good news is that you have already invested in a good table, so you can continue to work on your game. And your kids are the perfect age to start learning, and picking up good habits.
You might want to check out the rookie tournament on Mondays at the Balloon Inn. I've never been, but it looks like there's a good mix of skill levels showing up, and it seems to be run well. Check out the most recent post on this forum for details.
As for your kids...hmmm...there will be events for them at the national tournament in the Springs in July. One of the bad things about foosball is there doesn't seem to be a good place to develop young players. If there happened to be a table at an arcade, the rods are certain to be dirty and sticky, and the odds of decent young players being there are not good. My boy is 11, and I live in Littleton. Maybe you're actually a nice guy with decent kids, and we can get together sometime for a basement foos sesh.
By all means, show up at the Bonfire this Friday, maybe by 7:30, and play some warmup games, before the tourney starts at 8:30. You'll get a feel for it, and a few hours later, maybe Scott, Mark, Jim, or I will play some more with you, if we're eliminated from the tourney earlier than we want to be.
Nick