The southern end is at Noccalula Falls Park in Gadsden , Ala. , and follows Lookout Mountain Parkway and a trail of local roads and state highways out of Alabama and through a chip of northwest Georgia into Tennessee .