It was erected by the Metropolitan Drinking Fountain and Cattle Trough Association.
The photo probably dates from about 1900.
Drinking troughs and fountains became common sights in towns and cities from the middle of the 19th century.
Disease and illness were rife from poor sanitation, and cholera outbreaks in 1847 and 1858 killed thousands of people in London alone.
No table tennis medal for Worksop's Sam Walker at Commonwealth Games
Worksop Harriers ladies finish sixth in the Summer League after Teversal Trail finale
Bassetlaw Swim Squad's Lewis Warner makes history with silver in British Summer Championships
Worksop and proud: Graham Taylor, Lee Westood, Sheffield Wednesday's Liam Palmer and other sportspeople who helped put Worksop on the map
Tough start for Worksop Town as they head for Stockton Town opener
Water was in short supply and drinking water was often so dirty that nobody would risk drinking it, with most of the working population preferring to stick to beer instead.
In 1859 Samuel Gurney MP, a nephew of the social reformer Elizabeth Fry, was inspired by public drinking fountains newly installed by civic authorities in northern cities like Liverpool and Hull, to found the Metropolitan Free Drinking Fountain Association.
By 1867 provision of drinking troughs for animals was being included and the name was changed to the Metropolitan Drinking Fountain and Cattle Trough Association.
The cost of the clean water supply was met in some cases by the Association, in others by the local parish.