To add to what Bravo35223 said,
Yes, shopping in the QuadCities is limited...there is more in nearby Huntsville. Nightlife...there is some, thanks to Muscle Shoals' reputation with the late Fame recording studio and UNA students, but it is limited. There is some more in Huntsville and a LOT more in Birmingham. You are also only 2 hours from Memphis, and a couple to Nashville.
Although the counties are dry, the cities - Florence, at least - are wet. And in Alabama, dry means dry - no liquor, beer OR wine - and wet means wet - liquor, beer AND wine. No Sunday sales, though.
You will also want to look up the hard facts at
http://www.city-data.com/city/Tuscumbia-Alabama.html . Be sure to look up the stats for Florence, Sheffield and Muscle Shoals...they're all so close they flow into each other.