Flooding in north-western Tanzania has killed at least 38 people and left hundreds of others homeless, police in the Shinyanga region have told the BBC.