I searched the sub for urinating, peeing and fountains and couldn't find anything related to fountains that have peeing statues.
You are probably thinking of the one in Brussels, which is probably the most famous one. It was based on a well-known legend where a little boy either peed on a burning fuse and prevented an explosion or some other form of destruction to the city.