A father-of-two who served in Afghanistan has been denied a council house because he has not been living in his local area while serving in the forces.