Wayne Green 41, had refused to leave a boat on the canal behind the Plough Inn pub on Wednesday evening.
Armed officers surrounded the boat, closing off a stretch of the canal and the Town Street pub, while police negotiators spoke to him.
Just before 5.30am on Thursday, he gave himself up after 12 hours.
Rumours among the dozens of Sandiacre residents gathered at the scene were rife that Green, of Long Eaton, had taken a hostage and was armed with a shotgun.
But police have confirmed that no weapon was found on the boat and there had been no hostage.
A police spokesman said that a girl had been aboard during the stand-off in a bid to talk Green round.
Ian Barrowcliffe, who has recently moved to Doncaster Avenue in the town from Ilkeston, was one of the crowd watching events unfold.
He said: “It’s a bit of a shock, really.
“It’s not what you expect to see near your house on a Wednesday night.”
Another bystander said: “Nothing like this has ever happened before.
“You get the odd drunk causing trouble, but never anything like this.”
When Green, who is also known as Stephen Cross, stepped off the boat, he was arrested and later charged with two counts of criminal damage, threats to cause damage, failure to comply with a Violent Offender Order, possession of cannabis, assaulting a police officer, making threats to kill and an offence relating to harassment.
He appeared at Derby Magistrates Court on Friday, where he was remanded in custody, and is due to appear again on Thursday.
The five-year Violent Offender Order – the first one ever imposed in Derbyshire – banned Green from contacting named individuals or entering Long Eaton.
Crimestoppers had previously offered a £1,000 reward for information leading to his arrest.
Derbyshire police this week thanked staff at the Plough Inn for their co-operation during the incident.