Houston police say a gunman opened fire randomly on passing cars, injuring three people, before he was shot by responding officers on the scene.