Most wireless hot spots are configured automatically via DHCP so that the user is automatically connected to the internet as they move between locations.
For the VPN portion once the VPN connection is set up on the client it can be called at login time.
Exactly how it is done depends on the client OS.
Here is a tutorial for setting up a VPN on a Vista client.