What would the proper usage of the apostrophe be in this situation?

"The Club, by Brawny" would be the best. If you reeeeeeally wanted to use an apostrophe, I would say Brawny's Club.