Sports complex brings community together after £1.2m investment