I would suggest the Sigma 105mm f2.8 DG DN Macro Art since it fits your budget. Just be careful though, because macro depth of field is paper thin. Yo...
Jumping in real quick because I've been down this road before. A few years back I took my older RX100 to Florence-similar cobblestones, similar stress...