I can't really give you info on the career prospects since I have yet to graduate and look for a job in the legal field. I know there are a lot of big companies in ATL, as Coyote mentioned, and I didn't anyone who had trouble finding a job. Not like that's a concrete answer, but it's as much as I know.
As for safety, I was a single female living in the city and I never once felt unsafe. If you're going to Geogia State I probably wouldn't recommend living too close to the school. And then the question is how important a yard is to you. Not too many nicer homes near Georgia State - a lot of great condos, especially in midtown. Most are a bit pricey. But if you don't mind commuting a bit, there are so many great areas and a lot of them quite affordable. Cobb county (Kennesaw and some parts of Marietta) is a great area for kids and families. Good schools, too. But this is if you're willing to commute a bit. Paulding county has really low property tax which is attractive, but it's a fairly long commute.
Are you looking for homes, apartments or condos?
As for things to do... infinite possibilities. I was talking to one of my best friends who is from Dallas and we were comparing things to do in ATL v. Dallas and from our conversation ATL was the winner. That's especially true in the music arena. Seems like you had better love country music in Dallas. And judging from our conversation there seemed to be more lounges and not just bars in ATL. What I mean is a pseudo-bar where you can actually sit and talk with others. One of my favorites is Compound that just opened up last spring. www.compoundatl.com
It's great because there's live music in the outside club, a non-smoking club and then there's a 3rd club where it's smoking. It's like 3 clubs in one! Actually there's a 4th one, too, but I've only been there once for a party - you have to rent it.
And since you have kids, you can't beat Piedmont Park (not too far from Georgia State.) And since you're from up north you might even feel at home in the outdoor ice skating rink they put up in Centennial Park every winter. I don't have kids, but I did Big Brothers Big Sisters when I lived there and there were so many kid's fairs, shows and events to choose from.
Does that answer some of your questions / concerns?