A Staffordshire bull terrier has been rescued after spending five nights trapped in a storm drain.