ci: standardise workflows using SciML's reusable workflows

[thazhemadam]

Update the workflows in this repository to use SciML's reusable workflows. This is part of a larger effort to standardise the SciML's CI workflows for more generic and common requirements, to keep the workflows uniform and easier to maintain.