Council leaders say the hub will be a “community asset” but locals fear high costs, loss of green space and increased traffic