most upscale downtown hotels are pretty hush hush about their visitors. however if you want your guests to visit at night, usually the easiest and best places are outside of downtown. Motel Village on 16th and crowchild has a selection of venues. the holiday inns down on Macleod trail S are pretty lenient and theres a few days inn's in the NE too.
as for food, if you want big fancy meals, check out Charcut downtown.
for local grown - Dairy Lane or Downtown Foods
nice pubs/restaurants - Craft, National, ect.
hope you have a great visit to Calgary.