What's the best way to seal around this faucet?
I like clear silicone caulk for this kind of job.  

It will remain flexible after curing, so if the pipe gets bumped or moved around it won't break or crack like expanding foam.  And the clear caulk won't stand out since it cures to a translucent light grey color which is similar to the siding.