From hotels on the moon to a life-changing 'overview effect', veteran NASA astronaut lifts the lid on the future of space travel - and it could be possible in just two years' time