Refactor!: Consolidate state, db directories and remove dead code

Consolidates rootless database state, extracts shared systemd plumbing, moves host-level state to common directory, removes dead code.