Path dependencies should be treated like workspace members

We currently treat workspace crates specially, by watching their source files and giving them "low" salsa durability. I think we should do the same thing for `path = "..."` dependencies to better match Cargo's behavior (which will watch them for changes). Currently we treat them the same as crates.io dependencies and the sysroot, assuming that they never change.