With an Emirates visa, you can stay in UAE till the stay validity of the visa expires and visit the tourist spots.