I am from the Jackson area, grew up and lived there my whole life before moving to Houston after college. I created this account just to drop my two cents on this topic, DO NOT move to Flowood or Brandon. I suggest you move to Madison or Gluckstadt. That is by far the best two areas in the region to live, no crime, affordable housing, and the schools in that district are great.
Depending on how old you are, and your family situation, I would also recommend moving to the Fondren area...it is more of a young crowd 25-30ish, it is becoming an artsy area, they have great restaurants, and there is always something going on. It is not as family oriented as Madison County, but for a young couple it would absolutely be a fun place to live.
Hope it works out for you.