What a real spaceship would look like
Or could look like, based on technology we already have or have within our grasp:
The video is from 2011, so no doubt there have been many revisions since. A similar, but more advanced looking ship was used in the movie The Martian. No doubt based on this design.
So when are we going to see this ship for real? Not in my lifetime, I expect. In a world where industrialized, technologically advanced nations are over budget, bordering on bankruptcy and/or currency collapse, I don't realistically see funding for projects like this for a long, long time. If ever. It may remain just a dream, only fulfilled in movies. CGI special effects are so much cheaper than reality.
For more photos from the movie, and commentary of the science, follow this link: SCIENCING THE MARTIAN