You cant get a visa on arrival at Dubai Airport...but can get a visit visa through Emirates Airlines Holidays...for that you'll have to stay in one of their designated Hotels as per their different packages.