A £96 million train station has been given the green light in a major city, with locals hoping it will boost public transport infrastructure across the region.