Col. Sharon Asman, 42, who entered top role in Nahal Brigade just last week, survived by wife and two daughters; army investigating his death