Weekend number 2 of Cork Midsummer Festival features a tour of local homes to view their art, dancing with buckets, and more, says Ellie O’Byrne