I have not found screw on lids but you may want to look at the waterproof stainless food containers from Olicamp. These have spring clamp lids.
I have looked at, but did not buy the small size one.

These are available in 0.5, 0.75, 1.5, 2 L sizes. Not exactly beer can shape but may work.
Search on Olicamp but this image is from:
http://www.campstuff.com/acatalog/Individual_Cook_Pots.html