I'm sorry to say, but the Creation Kit will not be available to the consoles for a number of reasons.
1) Bethesda created the Creation Kit to build the game world. They build the game world on the PC, just like how they use Photoshop and 3DS MAX on the PC and not on the consoles. So the main purpose of the Creation Kit is to be a tool to make the game development easier, that they then can give away their tool for free is just an added bonus.
2) Sort of related to 1, it's a waste of money to develop a Creation Kit that they will never use. They already built the game world on the PC, why would they develop specific console versions? It won't benefit their game development in any way.
3) The Creation Kit is a Windows program and heavily use the specific Windows APIs that aren't available on the consoles. To port it to the consoles would not only take a lot of paid development time, it wouldn't be easy either.
4) The Creation Kit use noticeably more RAM than the game itself. The consoles doesn't have enough RAM to run the Creation Kit.
5) If there was a crippled console Creation Kit (why on earth would they release a crippled product!?), it would still eventually run out of RAM because the town got too big or whatever, and cause the console to crash. While a PC practially can't run out of RAM, it will just increase the pagefile.
Then there are the extra work on how mods should be distributed on the consoles and so on. Not to mention that a lot of PC people who try mods make their games unreliable and the PC starts to crash noticeably more, so more support is needed as well, not only from Bethesda, but from Microsoft and Sony as well.
So yeah, if you want to play around with the Creation Kit, you need to buy the PC version, sorry.
And before you say it can't be done, IT CAN! If Ubisoft Montreal can include and AMAZING map editor on consoles (Far Cry 2)
Compared to the Creation Kit, the Far Cry 2 editor is really basic, it's not a fair comparison.