Ideally, one should be able to add a new shipping method and declare it as "In-Store Pickup".

They key to this is that it would ignore products' shipping freight field.