In the final dungeon, there's an area surrounded with red water. On the lower floor of this place, just before the stairs going downward, you'll find the spot where you can use the harp.
Also just as a head's up, Castle Darkloft isn't the final dungeon.