The tricky part will be getting the seeds to germinate. First, because a tree may produce seeds but it has to be a mature tree to produce viable seeds. and second, even if viable, they are really stubborn about germinating.
The Giant Sequoias don't grow as fast as regular redwoods but they are not suited to a small yard. The good news is that you won't have to worry about that in your lifetime.