Local residents' photos and memories of flooding are in the spotlight as the Waters Rising exhibition opens at Perth Museum