A father shot dead three of his children before killing himself after a stand-off with police in Texas.