You can get a train from Glasgow central to Motherwell about once every 30 minutes. You probably actually want to get a train that goes through Airbles station which is in Motherwell but a good bit closer to the stadium and right next to the "Electric Bar" where the Aalesunds supporters seemed to have a good time. Another popular pub is Jack Daniels which is just up the hill from Airbles station on the left hand side. There wont be any need to book train tickets in advance, you can purchase them in the station or even on the train itself.