People 'incredibly happy' over speed limit reduction on Shropshire road named as one of country's most dangerous, councillor says