A stand-off involving armed police ended peacefully after more than 24 hours following the arrest of a man.