From my research, SAE 660 Bronze is probably the most machinable that would be useable for a barrel, though I'd recommend a seamless steel liner if it is a large bore. For small guns (probably no larger than ~.50 cal in my mind), the liner may not be as necessary, as the pressure levels become similar to a pistol barrel.
Most people don't recommend using brasses, as the high zinc content tends to make them brittle (i.e. prone to catastrophic failure). There are a number of other bronzes which may be better suited for cannon, but most of them have low machinability, and are therefore usually cast.
BTW, don't just take my word for it, as I contracted with a builder on here to make me a bronze handgonne, but he stopped communicating with me when it was almost finished, so I don't actually have any bronze barrels, but it was being made of 660. Others on here with bronze barrels have at least 1" unlined 660 barrels.