The country singer broke down onstage, and dedicated his award to his late drummer and friend Kenny Dixon