There are quite a few options for the local development, from installing the server and the database locally to some of the virtualised solutions, mostly based on Docker. Three of them stands out, Docksal, Lando and DDEV. My research showed that although all are quite similar in the approach, DDEV has very agile pace of development, covers many use cases, offers a lot of integrations and had the flexibility to be customised and automated for your most efficient workflow. You'll see what else DDEV can do for you beside just spinning local website.