Heavy rains across Canada and US cause 'devastating' floods and spark evacuation