On the heels of his new country album Look Up, the former Beatles drummer will play the Nashville institution in February