Gordon Brown has indicated he is "very keen" to join Labour's by-election campaign in Glenrothes, the Scottish secretary says.