I’ve used SMS Backup & Restore for several years to do exactly what you describe.

Everything backs up to a local folder on my phone and I sync to my home server. The app can sync backups to a cloud storage, but it isn’t required.