SharePoint Site Workflows using Visual Studio

Create a Custom Site Workflow Activity
Site level workflow from visual studio
 http://msdn.microsoft.com/en-us/library/ee231574.aspx

Create Workflow using Visual Studio
http://msdn.microsoft.com/en-us/magazine/ee335710.aspx

More on workflows
 http://msdn.microsoft.com/en-us/gg620624