The Johnston YMCA in NoDa is a nice facility. It's not nearly as crowded as the other Y facilities. It's reasonably priced if you purchase a membership just for that facility as opposed to a city-wide membership. You'll also meet folks from the neighborhood there.
Dave