A man who terrorised a family in a “drunken rampage” during which he assaulted two children, smashed windows and made threats to kill has been sentenced to two and a half years in prison.