We have a Virtual Network of VMs, storage accounts and websites hosted and working together in the Azure cloud.
Is it possible to connect my work/home PC to this Virtual Network using some VPN software?
Generally speaking two options exist, you can read about these here -
Also worth reading is this overview of Windows Azure Networking features that covers both (and Traffic Manager) by David Chappel