There aren't going to be many accommodations along the trail in terms of motels. I know there is a hotel or motel at the western end of the trail. The area is very rural once outside of the Atlanta Suburbs. There are a couple of campsites.
I think the most interesting parts of the trail are from Hiram to Rockmart although I've not explored into Alabama much.
You could contact @
jppe who just rode the whole trail with an overnight in Piedmont. See
Day 2 Silver Comet & Chief Ladiga Trail
You might also get some feedback at
https://www.atlbike.org.
-Tim-