“Despite its success, the creation of supportive housing has fallen far short of the need—in large part because of fierce resistance by local residents.”