It really sounds like you're thinking of a character from 'Animaniacs'. They had a segment called 'The Goodfeathers', and I'm pretty sure one of the birds was a detective type. Not a duck per se but the red jacket and hat fits.