This unsung Scottish city boasts acclaimed festivals and year-round thrills