EA announced that "The Sims 3" will be available on Xbox 360, PlayStation 3, Wii and DS consoles this fall. The game play will basically be the same as on the PC, it's still the Sims . However, there may be some interesting differences. EA states that the Wii version will have a co-op mode were "A second player can join the fun as a gnome who can help - or hinder - your Sims."
You can read the full announcement at The Sims 3 website.
If you'd rather like to see some moving pictures you may want to have a look at the preview of a Sims parody of Iron Man 2.