Slow-moving Tropical Storm Harvey has killed at least eight people and paralysed the fourth most-populous US city with unprecedented flooding.