A footballer has died in hospital after suffering a 'serious head injury'.