I find Mérida completely safe for both visitors and residents.
CeoWorld Magazine ranked Mérida as the second safest city in North America in 2019. Just like any other big city, Mérida has areas that are safer than others. Always maintain situational awareness wherever you are.
Most Mexicans find the idea of drinking tap water somewhat repulsive. Do as the locals do and do not drink the tap water.