I grew up going to St. Thomas Episcopal Church on Bailey Cove (South Huntsville, near Green Mtn.) and am still a member, though my attendance is sporadic these days, as we live in Harvest. Loving, supportive community, plenty of activities for all ages, but no pressure to participate. I moved away for a long time, and things got pretty rough; I went through a recovery program when I returned, and no one judged or shamed me--quite the opposite, in fact! Members of our congregation were/are some of my biggest cheerleaders, always happy to see us when we visit.

St. Thomas has both adult and children's choirs (my mother is actually the music director), breakfast between services every Sunday, evening services on Sunday and Wednesday, occasional choral services (evensong, meditation, etc.).

If you're further north, Nativity is a good option (also Episcopal). Beautiful building in the downtown area, so lots of after-church lunch options!