Sporting facilities at two Birmingham parks are set to be upgraded after a “fantastic” scheme was given the green light.