Now that the Massachusetts legislature has passed the revisions in the law it is looking very likely that the new Senator will be former DNC official Paul Kirk. Governor Patrick still has to do some paperwork to allow him to make the appointment now but that is a mere formality.
Update: Kirk has been appointed.