Update Patroni and Consul config to use Omnibus Roles and latest guidance

Following guidance from the dev team enabling Patroni and Consul is best handled via their respective Omnibus roles.

There's also some additional config for Patroni in setting postgresql['sql_replication_password'] and setting the correct number of replication slots.

These changes shouldn't affect backwards compatibility so that's thankfully not a consideration.

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information