Give them as much notice as you can, but take the job you want. The job you desire will help you for the rest of your career, but your current company just has a short term personnel problem. Most important is to take care of yourself and your family (current or future) first.