The mayor of Milan has signed an ordinance turning off the taps of public decorative fountains and the city's archbishop has prayed for rain in a tour of churches as northern Italy endures one of its worst droughts in decades.