A three-part exhibition at CCA Wattis Institute for Contemporary Arts, San Francisco, draws on the ensemble form and musical score to deliver a vision of cacophonous community