Making it social is very effective. People who have a history of giving up on exercise often find that it's much harder to let other people down than to let themselves down.
Being social enough to benefit from this idea but not social enough to enjoy making smalltalk with a bunch of strangers, I never liked the club idea. For those who are less social like me, competitive amateur sports leagues that are segregated by ability and age are a nice alternative. Typically, facility access requires games to be strictly scheduled, ensuring that people play instead of chatting. The competitive aspect ensures a good workout, and there are options to play as an individual (singles tennis and racquetball) or as part of a team (softball, soccer, basketball.)
Team sport leagues usually provide some way of signing up as an individual. Either they'll place individuals with teams who need players, or they'll create "house" teams made entirely of people who signed up as individuals. You might be embarrassingly bad, but you probably won't be the worst. If you're playing in the lowest skill level for your age, nobody can really complain -- if they want better teammates, they should "level up" and play in a higher category.