Hi Jamie,
First I would say that choosing the archive format is equally as important as the codec.
Using LTFS on LTO5 or LTO6 will create an accessible archive allowing easy restore of selected clips.
Then regarding codec, use the same one that you can work with efficiently now. Changing to another may or may not ease access in the future, but it will certainly slow down your current workflow and also the archiving and future retrieval as it will involve transcoding.
In your case definitely use ProRes, whilst not a open standard there are open source decoders and encoders.
Also there has been a large increase recently in the number of third party cameras and other hardware that are creating ProRes which is the best way of prolonging a format.
In summary use your current working format and in the future as new LTO or other archive formats become available then review the situation. Ensure that your chosen codec is still your current post format and if not then whilst consolidating your material to a new archive, transcode to this new codec.
This way whilst preserving your assets indefinitely, you always have easy access to it for repurposing.
My company YoYotta creates workflow and archival software for the Mac, but having seen the rise and fall of many formats over the years I think this answer is valid for anyone on any platform.
Best,
Martin Greenwood
CTO
YoYotta.com