There are advantages and disavantages for using rolling release or release based distros.
Generally speaking rolling release distros needs maintenance more often (such as running updates and stuff), however you may choose not update. Anyway, rolling release distros are more up-to-date with the packages, if you care about it.
Release based distros requires less maintenance, cause its base is more defined. The maintenance would be update once in a while for security patches. Despite this kind of server may be installed for years with low maintenance, for once in a while you’ll be required to do a full update, changing the base.
I’m personally on the rolling release side. I run Arch Linux as a private VPN server in a old laptop. For once in a while I run pacman -Syyu (maybe once in a week) and that’s the maintenance I do with no issues. Arch Wiki itself is hosted on a Arch Linux server as well.
Anyway, if you want a release based distro I recommend Rocky Linux or Fedora Server. If you like rolling releases more, I’ll suggest Arch.