More than 30 people have been taken to hospital after a police helicopter crashed on to the roof of a crowded pub in Scotland.