One person has died and hundreds have been trapped in buildings after a huge downpour in Athens left most of the city's streets flooded.