A man who terrorised three members of his family including a professional footballer, with threats of violence, has been jailed.