Storm Desmond briefly created a new record-breaking waterfall as it sent torrents cascading over a famous landmark for the first time in centuries.