Welcome to the forum!
Metal inlays on a call aren't all too difficult. And, yes, soda can aluminum can be used for inlays. It will be a thin inlay but that's ok. It only affects the look of the call, not the function.
You're going to want to use something other than CA for inlays. I always use 2 part epoxy.
Also, you're going to want to use a tenon for metal inlays to provide added strength. Think of it like putting a washer on a bolt. Drill your blank for the duck call (normal bore is 5/8"). Then drill out a piece of metal at a larger bore (I usually drill at 3/4"). Then turn your blank down to 3/4" at the point where you want the inlay to be. This is the "bolt" in my analogy. The inlay is then the "washer" and should slide onto the tenon of your blank. You'll need to turn an additional piece of wood to fit over the tenon and snug up to the inlay. Think of that as the "nut" on a bolt. You'll glue all three pieces together with 2 part epoxy and clamp tightly.
That's a quick and general description. Let me know if something's not clear. Good luck!