The small town Tennesseean earned a top 5 pop hit in 1974 and later became a successful songwriter for others