Visiting Dubai - please suggest cheaper hotels and best places to visit i will be staying for 5 days.?

Please rate how much would a double bed & single bedroom cost per night & also suggest cool places to visit & -- night activities *shisha places and other good clubs.