First, answer 3 questions, then quality suggestions can be offered.
1. Do you have machining capability, lathe and mill?
2. What type of CW piece do you prefer to build, field gun, naval gun, siege gun, or seacoast gun?
3. All CW tubes are shorter than modern artillery for any bore size you can point to, so you will have to pitch a good portion of that 30mm tube, about half.
Right now, assuming you have a lathe or access to one, it looks like the 4.5" U.S. Iron Siege Rifle, Pattern 1861 looks like it has the longest tube per bore diameter. This would be approx. a 1/4 scale because your tube has a 1.181" bore diameter. This big rifle was 133" long which makes a 1/4 scale piece 33.25" long. This was one of the heaviest siege rifles on the battlefield and has a large wood siege carriage. What do you think?
Regards,
Tracy and Mike