Recommended workflow for local footprint changes?

The most natural solution is to create your own libraries. Check out the FAQ articles about Managing your projects, Library, Footprints and Symbols: (Start Here) Frequently Asked Questions.