Fans to be allowed alcohol in seats in radical overhaul of supporter experience