Wayne Rooney appointed manager of Birmingham City, joins NFL star Tom Brady in club's leadership