Our driver told us this was a water tower with a restaurant on top. According to a blog I found, it does hold a little bit of water underground (but not in the tower) and there is no restaurant on top, although there is an observation platform. It might be worth a visit at night for a view of the city, although the skyscrapers are probably better for that. Located next to the National Museum of Saudi Arabia: