Ummmm, yes you will without a liquor license
It is still UAE law that an expat on a resident visa requires a liquor license, if you are visiting then the hotel you are staying at are your 'sponsors' and technically you must always carry proof to the effect that you are on a tourist visa.
The liquor license isn't just for storing the booze in your household (which is supposed to be in limited amounts) but also for consuming it on public/private premises. If you screw the pooch and get in the poop it will be the first thing the authorities will try to hammer you on.
Whilst this law gets lost a little in Dubailand it is still Federal law.
An excerpt from the US consulate General for Dubai residents:
Drinking or possession of alcohol without a Ministry of Interior liquor permit is illegal and could result in arrest and/or fines and imprisonment.
Alcohol is served at bars in most major hotels but is intended for guests of the hotel. Persons not staying at the hotel who come in to use the bar technically are required to have their own personal liquor license. Liquor licenses are issued only to non-Muslim persons who possess U.A.E residency permits. Drinking and driving is considered a serious offense. Penalties generally are assessed according to religious law.