A siege in northern Brisbane has ended peacefully after a stand off with police which lasted more than eight hours.