Thousands flocked to the celebration of all things Scottish on New Year's Day