Where does your extended family live? If in N MS, then living in Gluckstadt will cut an hour round trip off the drive when you visit. If South MS, then Brandon will be closer.
Houses/land in 39042 Brandon will be cheaper. There are essentially two Brandons, Hwy 80 Brandon (the City of Brandon) is 39042 and 39047 Brandon is Rez/Flowood. If you buy a house near the water, it may the on Pearl River Valley Water Supply District Land (called leasehold), if so this will be an additional tax.
Although there are good schools in the metro, NWR, Brandon, MC and Germantown, private schools are growing like crazy.
We live in 39047 Brandon, not far off Hwy 25 which makes commuting to Starkvegas easier.