TwitSnap is a FREE widget that automatically provides Twitter status preview of a user.
The widget will automatically parse your page and look for the @pattern, convert it into a link to user's profile on Twitter and then provides a preview of the user's most current status via a pop-up dhtml box.
TwitSnap is built using Google Apps Engine (Python runtime), insane DHTML JavaScripts and of course uses the Twitter API. Read more about TwitSnap and other Web 2.0 and Mobile 2.0 stuff at my blog.
If you have some questions or how-tos; the TwitSnap blog will answer most of your FAQs there.