BSing,
There are not going to be the lake access that you guys are use too, however, there are a couple of small lakes in the Raleigh area. Don't forget you can get to the ocean in about 2 1/2 hours.
You guys will not have a problem at all getting jobs! The cost of living will be a huge change (especially when it comes to taxes); so don't forget to consider that when you see your salary change.
I'm actually selling a house in Johnston County, but its closer to the city (Raleigh) than the area that you are looking. I love Johnston County and as a born "Northerner" I'll tell you the reason that my wife and I chose to live here vs. Wake County.
As far as the schools most people will tell you that Wake County Schools are better, however, I have a bit different prospective. I would have to agree that Wake County School's have better academic numbers, but the following were more important to me!
REASSIGNMENT, meaning the parents in Wake County have to worry about their kids getting reassigned every year, which is terrible for children (no security). Wake County is very political and the school system illustrates that. I worked in a Wake County School as a School Resource Officer for a number of years and witnessed many things that made me come to the conclusion; I would never send my children to Wake County Schools.
SAFTEY, I could not refute the academic numbers, but the schools in Wake County are more violent and tend have more reported criminal violations. Again based on my experience!
COURTIOUS, People are so courteous in Johnston County. The only way I can describe it is this, I use to live in the "rat race" where you seldom spoke to people around you (grocery store ect) and people were just not very nice to one another.
I can go out in the City of Raleigh or Cary (Wake County) and people are just rude as hell!!! Some think it is the amount of Northerners that have moved there, which quite honestly could be a SMALL part of it, but I think it has to do more with the fact there are a lot of wealthy people (Southern and Northern) in those areas.
You will definitely get more house for your money in Johnston County. I have to move for employment reasons, but this area between Garner and Cleveland (40-42 area) is the best of both worlds!
I could write forever on the above topics, but I think that you will love NC regardless of where you move. If you come up on any specific questions, please feel free to contact me and I will help any way that I can. I can imagine how stressful the relocating will be, especially with little ones. Please don't hesitate if you have other questions!!!!!!!
sselvek@nc.rr.com