Is the well in the market functional?

No.

It is purely cosmetic and does not serve as a source of water during a fire. Source