A hostage drama in Florida ends with the death of four children at the hands of a gunman, who also took his own life, police say.