Tributes have poured in following the amateur footballer's tragic death