Enable transaction support in Gitaly in tests

What does this MR do and why?

Gitaly has a configuration flag that enables support for transactions with ACID properties. With the flag enabled, Gitaly runs each RPC in a transaction leading to improved reliability.

As a preliminary step towards rolling out transactions, this commit enables the use of transactions in test

Part of gitaly#5664
Closes gitaly#6021 (closed)