You have to do what's right for your family. You can't worry about what others may think--though if he DOES take the job, you don't have to broadcast it to family and friends...the only way they'd find out is if they went there themselves...and then, what could they say?
But, the question still remains--is your husband REALLY going to go to a place like that and NOT be affected by what he sees night after night? Remember, no matter how faithful your husband is, men ARE PROGRAMMED to respond to visual stimulation. Do you think that he won't be thinking of some of these women when he makes love to you? And, what message is it sending to your two boys? Does it tell them that it's ok to look at women this way? What do you teach them about pornography? About women? About strippers, lap dances, even prostitution?
Yes, it's important to pay your bills...and friends and family are not a reason to do or not do something, but your children are. Would YOU work in one of those places to pay the bills? How different is it?
I can't answer your question for you, but I hope these questions help you make your decision.