Welcome to Grand Rapids!
There are a lot of communities that will work for you. Rockford is a very nice community, but I think the commute will be more than your husband wants to do. It is north of the city, while Byron Center is south.
Byron Center Public Schools are fine and the private schools are also excellent. A lot of the other areas already mentioned are also very nice including Caledonia, Jamestown, Hudsonville, Grandville. Some parts of Wyoming are also very close to Bryron Center and is a very nice place to live.
The locations mentioned range from small town to suburban to quite rural. Will you have an opportunity to come and look around?
I am thinking your kids are young, but Grand Rapids also has great higher education opportunities including Grand Rapids Community College, Grand Valley State University, Calvin College, Hope College, Aquinas College and several others.
Again...Welcome to West Michigan!!