Rossini's "Cats' Duet". (Seriously. I've heard it done in a folk club so it must be folk). For Scottish stuff, you might try to find recordings of Gordeanna McCulloch and Chris Miles, or Janet Russell and Christine Kydd.