Is it old-fashioned to say "It's raining cats and dogs"? If yes, what is the substitution idiom for expressing heavy rain?
Perhaps nowadays the saying is less popular among young native speakers, it does sound a bit of a cliché. According to Google Ngram, the British English corpus shows its popularity has declined since its peak in the 1940s.
Whereas according to Google Ngrams, it seems that American English speakers are loving it, the chart shows a sharp increase in usage since the 1970s.
To add to the many colloquial sayings mentioned already by @Peter and @Jocie, the very common, but perhaps for some speakers offensive, phrase:
and the innocuous-sounding
It's pelting down
Yes, "cats and dogs" is still in use and almost all Americans will understand. There is also the airplane pilot's description of truly bad weather when driving a car: "It's IFR weather out there" (Instrument Flight Rules), meaning (jokingly) you can't see a dang thing through the windshield and you must use your car's oil pressure gauge to steer by.