Hundreds of people and their pets have been rescued in California after a neighbourhood in San Jose was submerged in water.