A major new BBC drama is among the films and TV shows shot in Sheffield which are set to hit screens in 2025.