When is compact induction cuspidal?
Suppose
(1) $K$ is open and contains a finite index subgroup of the center
(2) For every parabolic subgroup $P$ of $G$ with unipotent radical $N$, $\rho^{ N \cap K}=0$.
Then $\rho$ is cuspidal (i.e. a finite direct sum of super cuspidal representations).
I think the argument is (or finishes on) page 28 of the book Harmonic analysis on reductive $p$-adic groups by Harish-Chandra, if you can understand the notation.
But my understanding of the argument is that it is easy to check from (2) and the definition of the Jacquet module that the Jacquet module vanishes. If the Jacquet module vanishes, and the representation is admissible, then it is a finite direct sum of supercuspidals. To check that the induced representation is admissible, we must find its $K'$ invariants, which by Frobenius reciprocity reduces to finding the $g K' g^{-1} \cap K$ invariants for many all $g \in K' \backslash G/K$. Using the (affine) Bruhat decomposition you can check that, for all but finitely many $g$'s, $g K' g^{-1} \cap K$ contains $N \cap K $ for $N$ the unipotent radical of a parabolic subgroup.
That these conditions are necessary is straightforward.
A fun (?) exercise is to reprove that certain known constructions of irreducible supercuspidal representations are at least supercuspidal using this method instead of the $\rho$-intertwining condition.
The answer to the first question is no. The representation $V=\operatorname{ind}_K^G\rho$ is never cuspidal when $\rho$ is trivial. In this case V consists of smooth compactly supported functions on K\G while its contragredient consists of smooth functions on K\G. The matrix coefficient corresponding to the indicator functon of K and the constant function is not compactly supported modulo centre.
There is a positive answer to the second question. Bushnell-Henniart state in their first remark after Theorem 11.4 that this result is true assuming unimodularity of the locally profinite group G, with G/K countable for compact open G, such that every irreducible representation is admissible. Thus it holds for every reductive group over a local field, as well as their finite central extensions. A reference for the most difficult part, that irreducible implies admissible for reductive G, is Renard's book: Théorème VI.2.2.