The Roper's Gate is briefly described in the short story The Witcher. The witcher enters the city of Vizima through that gate and then heads immediately for the nearest tavern. It is one of the north gates into Vizima, but not otherwise described.
In the game, Vizima is described as having quite a few gates — interior and exterior — but none of them is named the "Roper's Gate". There is a gate shown on the game map of Vizima which is not named and it is the most northerly exterior gate. That could well be it.