From Czech soups to Memphis barbecue pits, beer has been earning its place in the kitchen for centuries. Christy Spring on the history of cooking with the can