Abu Dhabi has thus far taken a cautious approach to tourism, but all that is changing as it embarks on an ambitious programme to make the city a centre of cultural excellence. Iain Akerman reports on the art of investment