Are you & your family relocating from out-of-state or just doing a local relo? Since you asked about schools, I presume that you have at least one or more school-aged child(ren). Several Real Estate Pros on this forum have already beat me to the punch about http://www.GreatSchool.net;
however, another great source to consider is the Atlanta Business Chronicle which compiles school ranking data and statistics every year (in February or March) in their Education Guide insert. Info on private schools and colleges are also included. Call or email me with your current mailing address and we would be honored to send you a complimentary copy.
You mentioned that your husband's job will be relocating to Alpharetta. What is his threshold on drive time and/or distance to commute? This would be the first place to start when considering various geographical places to call home in the Atlanta metro area. Will you be working with the relocation department of your husband's employer? Have you selected a full-time Realtor to assist you in this very important task of selecting a new home? Many of your fears and concerns can quickly be eliminated or mitigated by starting with a knowledgable, professional Buyer's agent. Since it sounds like you are already focused on the North side of Atlanta metro, choose a professional who lives and works in the area.
My family & I work, live & play in the Northeastern portion of town in Gwinnett County. We have been here for well over 20 years and absolutely love it. Lots to choose from including: Mall of Georgia, Lake Lanier, Discover Mills Mall, Gwinnet Place Mall, the Gwinnett Arena, the Gwinnett Civic & Cultural Center, wonderful parks & recreation facilities, and the soon-to-be Braves minor league stadium, to name just a few. Cities like Suwanee and Buford would be high on my recommendation (both have ranked in the top 10 of Money magazine's best places to live).
What other features, attractions and conveniences will be important to you and your family? Consider this exercise: have each member of the family make a list of their top 3 choices of wants/needs/would like in a home and location. Then, compare your notes to fine-tune the areas to focus on.
Wishing you much success for a smooth and stress-free relocation.