EXCLUSIVE: Brenda plays Detective Chief Inspector Vera Stanhope in long-running show and it's going to go out with a bang – but the actress isn't done yet