No — Merida locals drink bottled water. Tap water in all Mexico is not safe to drink for anyone, so no one drinks straight tap water in Merida. Since locals don't want to get sick just as much as you don't want to get sick, there will be no instance when anyone will serve you tap water.