I was in Herford for nearly 4 years. You definitely do NOT want to be in Bad Salzuflen or Bunde - both nice towns in their own right, and nice to visit etc, but EVERYTHING is on camp, and wherever you live in Herford you'll only be at most 10 minutes drive away. I used to live 5 minutes drive, and used to occasionally walk to camp, took about 20 minutes. If you were living in Glatzer, you're perhaps just that wee bit too far to walk, but not even 10 minutes away in the car. I had loads of pals live down there, the houses are fine. Plus you're easy walking from a nice park and the naafi. And Lidl!
Bunde and Bad Sal are about 20 minutes drive away.
As for Herford itself; well, I found it quite cliquey at times but all in all it's pretty friendly. There was a mums and tots group on a Wed morning, as I recall, which was a good start to meet folk. There's also a pretty good soft play area for the kids on camp, open all day which is handy. There's a cafe next to it which I think is open in the morning. You can flop on the sofa with a cuppa while the kids run wild.
The creche/nursey/pre-school was very good. The staff were lovely. My ds went from about 18 months old until he was over 3, and still talks about it!
Away from camp, there is a terrific swimming pool complex called H2O - slides, kiddie pool, outdoor pool, wave machine, it's great and good for hot days. Think it was pretty cheap too. Your kids will LOVE it.
You can use the gym on camp too, if you're so inclined, otherwise loads of people I knew joined private local gyms that had creche facilites - think they only cost about 20 euros a month.
Be warned that everything in Germnay is closed on a Sunday - excluding most bars/restaurants. The naafi is open in the morning (but beware of ultra-ignorant can't-be-arsed teenage staff!) but supermarkets and all shops are closed. Also, the naafi is really over-priced - don't be scared of shopping at the local German supermarkets as they are way cheaper and generally sell familiar brands. (Use the naafi for tea-bags, HP, heinz beans - stuff like that you won't find in the German shops!) Lidl is fab and just about everyone shops there.
Wow, didn't mean to ramble on for so long. All I really meant to tell you was, DON'T live in Bunde or Bad Sal!