Country singer Pat Green's younger brother, sister-in-law, and the couple's two young sons are dead after being swept away in Texas floods.