You can play in Stonesense, though it's still early days yet and only works on the last patch.

http://www.wired.com/2014/07/dwarf-fortress-3d/

Thanks for the link. While it does indeed looks nice, it's not what I had in mind. This is basically isometric 2D. You're looking at a plane. Things that rise up, like pillars, are not shown. You could not see that dam the way it really looks like in my linked picture.

We're getting there. mifki's working on getting multilevel rendering for basic tilesets (http://www.bay12forums.com/smf/index.php?topic=138754.105) and then that will be exploring 3d. Stonesense itself is headed in that direction, see the most recent forum page: http://www.bay12forums.com/smf/index.php?topic=106497.1035

A good 3d GUI for DF would be challenging. Usually[1] most of the game takes place in corridors/caves that are underground, so the naive approach would have everything obfuscated by solid rock.

[1] Obvious nitpick: some players do indeed challenge themselves to build everything above ground.